1 -- phpMyAdmin SQL Dump
2 -- version 4.1.14
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: 127.0.0.1
6 -- Generation Time: Jul 06, 2018 at 10:44 AM
7 -- Server version: 5.6.17
8 -- PHP Version: 5.5.12
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET time_zone = "+00:00";
12
13
14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17 /*!40101 SET NAMES utf8 */;
18
19 --
20 -- Database: `projectmms`
21 --
22
23 -- --------------------------------------------------------
24
25 --
26 -- Table structure for table `bloodgroup`
27 --
28
29 CREATE TABLE IF NOT EXISTS `bloodgroup` (
30 `bg_id` int(11) NOT NULL AUTO_INCREMENT,
31 `bg_name` varchar(12) NOT NULL,
32 PRIMARY KEY (`bg_id`)
33 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
34
35 --
36 -- Dumping data for table `bloodgroup`
37 --
38
39 INSERT INTO `bloodgroup` (`bg_id`, `bg_name`) VALUES
40 (1, 'O+'),
41 (2, 'O-'),
42 (3, 'AB+'),
43 (4, 'AB-'),
44 (5, 'A+'),
45 (6, 'A-'),
46 (7, 'B+'),
47 (8, 'B-');
48
49 -- --------------------------------------------------------
50
51 --
52 -- Table structure for table `booking`
53 --
54
55 CREATE TABLE IF NOT EXISTS `booking` (
56 `booking_id` int(22) NOT NULL AUTO_INCREMENT,
57 `dname` varchar(22) NOT NULL,
58 `userid` int(22) NOT NULL,
59 `dcontact` varchar(22) NOT NULL,
60 `expertise` varchar(22) NOT NULL,
61 `fee` varchar(22) NOT NULL,
62 `pname` varchar(22) NOT NULL,
63 `pcontact` varchar(22) NOT NULL,
64 `email` varchar(111) NOT NULL,
65 `address` varchar(22) NOT NULL,
66 `dates` date NOT NULL,
67 `tyme` varchar(22) NOT NULL,
68 `payment` varchar(22) NOT NULL,
69 PRIMARY KEY (`booking_id`)
70 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
71
72 --
73 -- Dumping data for table `booking`
74 --
75
76 INSERT INTO `booking` (`booking_id`, `dname`, `userid`, `dcontact`, `expertise`, `fee`, `pname`, `pcontact`, `email`, `address`, `dates`, `tyme`, `payment`) VALUES
77 (13, 'Md. Azharul Islam', 1007, '01521470368', 'Cardiologist', '800', 'azad', '01521470368', 'azad.ece13@gmail.com', 'Dhaka', '2018-07-27', '11.00am', 'bKask'),
78 (14, 'Dr. Majedul Islam', 1008, '01734761999', 'Medicine', '800', 'patient', 'contact', 'mamun@gmail.com', 'Dinajpur', '2018-07-28', '03.00pm', 'bKask'),
79 (15, 'Md. Azharul Islam', 1009, '01521470368', 'Cardiologist', '800', 'mamun', '01521470368', 'mamun@gmail.com', 'Rangpur', '2018-07-26', '11.00am', 'Rocket'),
80 (16, 'Dr. Badol Miah', 1004, '01949389983', 'Kedney', '700', 'mamun', '01521470368', 'mamun@gmail.com', 'Dinajpur', '2018-07-20', '11.00am', 'bKask'),
81 (17, 'Dr. Azharul Islam', 1002, '01764761919', 'Medicine', '500', 'azad', '01521470368', 'azad.ece13@gmail.com', 'Rangpur', '2018-07-26', '03.00pm', 'bKask'),
82 (18, 'Dr. Badol Miah', 1004, '01949389983', 'Kedney', '700', 'dezazad', 'dezazad', 'devloperazad.hstu@gmai', 'Dinajpur', '2018-07-07', '11.00am', 'Rocket'),
83 (19, 'Dr. Rashid', 1003, '01521670654', 'Medicine', '600', '', '', 'developerazad.hstu@gmail.com', '', '2018-07-15', '11.00am', 'bKask');
84
85 -- --------------------------------------------------------
86
87 --
88 -- Table structure for table `category`
89 --
90
91 CREATE TABLE IF NOT EXISTS `category` (
92 `id` int(22) NOT NULL AUTO_INCREMENT,
93 `cat` varchar(22) NOT NULL,
94 PRIMARY KEY (`id`)
95 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
96
97 --
98 -- Dumping data for table `category`
99 --
100
101 INSERT INTO `category` (`id`, `cat`) VALUES
102 (1, 'Medicine'),
103 (2, 'Heart'),
104 (3, 'Bone'),
105 (4, 'Kedney'),
106 (5, 'Cardiologist'),
107 (6, 'Plastic Surgeon'),
108 (7, 'General Physician'),
109 (8, 'Neurologist');
110
111 -- --------------------------------------------------------
112
113 --
114 -- Table structure for table `contact`
115 --
116
117 CREATE TABLE IF NOT EXISTS `contact` (
118 `contact_id` int(11) NOT NULL AUTO_INCREMENT,
119 `firstname` varchar(10) NOT NULL,
120 `lastname` varchar(10) NOT NULL,
121 `email` varchar(15) NOT NULL,
122 `comment` varchar(111) NOT NULL,
123 PRIMARY KEY (`contact_id`)
124 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
125
126 --
127 -- Dumping data for table `contact`
128 --
129
130 INSERT INTO `contact` (`contact_id`, `firstname`, `lastname`, `email`, `comment`) VALUES
131 (1, 'Azharul', 'Islam', 'azad.ece13@gmai', 'My comment is getting successful.'),
132 (2, 'zahid', 'hasan', 'hasan@gmail.com', 'good job');
133
134 -- --------------------------------------------------------
135
136 --
137 -- Table structure for table `doctor`
138 --
139
140 CREATE TABLE IF NOT EXISTS `doctor` (
141 `doc_id` int(22) NOT NULL AUTO_INCREMENT,
142 `doctor_id` varchar(22) NOT NULL,
143 `name` varchar(22) NOT NULL,
144 `address` varchar(100) NOT NULL,
145 `contact` varchar(14) NOT NULL,
146 `email` varchar(22) NOT NULL,
147 `expertise` varchar(22) NOT NULL,
148 `id` int(11) NOT NULL,
149 `fee` varchar(111) NOT NULL,
150 `userid` varchar(22) NOT NULL,
151 `password` varchar(22) NOT NULL,
152 `pic` varchar(111) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
153 PRIMARY KEY (`doc_id`)
154 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
155
156 --
157 -- Dumping data for table `doctor`
158 --
159
160 INSERT INTO `doctor` (`doc_id`, `doctor_id`, `name`, `address`, `contact`, `email`, `expertise`, `id`, `fee`, `userid`, `password`, `pic`) VALUES
161 (1, '2', 'Dr. Abdul Kader', 'Dinajpur', '01734761999', 'kader@gmail.com', 'Heart', 2, '500', '1001', '123', 'doctor1.jpg'),
162 (2, '1', 'Dr. Azharul Islam', 'Dinajpur', '01764761919', 'azad.ece13@gmail.com', 'Medicine', 1, '500', '1002', '123', 'doctor5.jpg'),
163 (3, '1', 'Dr. Rashid', 'Rangpur', '01521670654', 'rashid@gmail.com', 'Medicine', 1, '600', '1003', '123', 'doctor1.jpg'),
164 (4, '4', 'Dr. Badol Miah', 'Dhaka', '01949389983', 'badol@gmail.com', 'Kedney', 4, '700', '1004', '123', 'doctor5.jpg'),
165 (5, '5', 'Dr. Nur Mohammad', 'Dhaka', '01674546856', 'nur@gmail.com', 'Cardiologist', 5, '700', '1005', '123', 'itsme.jpg'),
166 (6, '1', 'Dr. Majedul Islam', 'Dhaka', '01734761999', 'majedul@gmail.com', 'Medicine', 1, '800', '1006', '123', 'itzme.jpg'),
167 (7, '8', 'Dr. Rafiq Ahmed', 'Rajsahi', '01674546563', 'rafiq@gmail.com', 'Neurologist', 8, '600', '1007', '123', 'doctor5.jpg'),
168 (8, '3', 'Dr. Sajedul Islam', 'Rangpur', '01521768936', 'sajedul@gmail.com', 'Bone', 3, '700', '1008', '123', 'doctor1.jpg'),
169 (9, '6', 'Dr. Abul Kalam', 'Pabna', '+8801976564536', 'abulkalam@gmail.com', 'Plastic Surgeon', 6, '500', '1009', '123', 'doctor5.jpg'),
170 (11, '11', 'Md. Azharul Islam', 'Dhaka', '01764761919', 'azad.ece13@gmail.com', 'Neurologist', 0, '800', '1012', '123', 'doctor1.jpg'),
171 (12, '11', 'Azharul Islam', 'Dhaka', '01764761919', 'azad.ece13@gmail.com', 'Heart', 0, '800', '1011', '123', 'doctor5.jpg'),
172 (14, '', 'Md. Azharul Islam', 'Dhaka', '01521470368', 'azad@gmail.com', 'Bone', 0, '800', '1016', '123', 'itsme.jpg'),
173 (16, '', 'Dr. Azad', 'Rangpur', '01521470368', 'azad@gmail.com', 'General Physician', 0, '1005', '1013', '123', ''),
174 (17, '', 'Md. Azharul Islam', 'Rangpur', '01764761919', 'hasan@gmail.com', 'Neurologist', 0, '600', '1015', '123', 'header3.jpg');
175
176 -- --------------------------------------------------------
177
178 --
179 -- Table structure for table `donation`
180 --
181
182 CREATE TABLE IF NOT EXISTS `donation` (
183 `donation_id` int(11) NOT NULL AUTO_INCREMENT,
184 `name` varchar(100) NOT NULL,
185 `address` varchar(100) NOT NULL,
186 `unit` varchar(2) NOT NULL,
187 `dates` date NOT NULL,
188 `email` varchar(222) NOT NULL,
189 PRIMARY KEY (`donation_id`)
190 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
191
192 --
193 -- Dumping data for table `donation`
194 --
195
196 INSERT INTO `donation` (`donation_id`, `name`, `address`, `unit`, `dates`, `email`) VALUES
197 (1, 'Mazhar', 'khulna', '1', '2017-11-07', 'abul@gmail.com'),
198 (2, 'Mokarrom', 'Saidpur', '2', '2017-11-11', 'mamun@gmail.com'),
199 (3, 'Azad', 'hstu', '2', '2017-01-21', 'mamun@gmail.com'),
200 (4, 'sumaiya', 'Saidpur', '1', '2017-11-15', 'azad.ece13@gmail.com'),
201 (5, 'Al-Mamun', 'hstu', '1', '2017-12-05', 'azad.ece13@gmail.com'),
202 (6, 'Azad', 'aaa', '2', '2017-12-29', 'azad.ece13@gmail.com'),
203 (7, 'Md. Azharul Islam', 'Dhaka', '2', '2018-05-12', 'azad.ece13@gmail.com'),
204 (8, 'Md. Azharul Islam', 'Dhaka', '1', '2018-05-10', 'azad.ece13@gmail.com');
205
206 -- --------------------------------------------------------
207
208 --
209 -- Table structure for table `feedback`
210 --
211
212 CREATE TABLE IF NOT EXISTS `feedback` (
213 `id` int(11) NOT NULL AUTO_INCREMENT,
214 `email` varchar(22) NOT NULL,
215 `feedback` varchar(22) NOT NULL,
216 PRIMARY KEY (`id`)
217 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
218
219 --
220 -- Dumping data for table `feedback`
221 --
222
223 INSERT INTO `feedback` (`id`, `email`, `feedback`) VALUES
224 (1, 'azad.tee@gmail.com', 'easy way'),
225 (2, 'azad.ece13@gmail.com', 'nice getting you');
226
227 -- --------------------------------------------------------
228
229 --
230 -- Table structure for table `patient`
231 --
232
233 CREATE TABLE IF NOT EXISTS `patient` (
234 `id` int(11) NOT NULL AUTO_INCREMENT,
235 `name` varchar(22) NOT NULL,
236 `age` varchar(22) NOT NULL,
237 `contact` varchar(22) NOT NULL,
238 `address` varchar(22) NOT NULL,
239 `bgroup` varchar(22) NOT NULL,
240 `email` varchar(111) NOT NULL,
241 `password` varchar(22) NOT NULL,
242 PRIMARY KEY (`id`)
243 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
244
245 --
246 -- Dumping data for table `patient`
247 --
248
249 INSERT INTO `patient` (`id`, `name`, `age`, `contact`, `address`, `bgroup`, `email`, `password`) VALUES
250 (1, 'Md. Azharul Islam', '21', '01746314882', 'Dinajpur', 'O+', 'azad.ece13@gmail.com', '1234'),
251 (2, 'Al-Mamun', '22', '01746314882', 'Saidpur,Rangpur', 'AB+', 'mamun@gmail.com', '123'),
252 (3, 'test name', '22', '01765674567', 'Dinajpur', 'A-', 'test@gmail.com', '123'),
253 (5, 'developerazad', '21', '01764761919', 'Dhaka', 'O+', 'developerazad.hstu@gmail.com', 'developerazad'),
254 (6, 'developerazad', '22', '01521470368', 'Dhaka', 'AB+', 'developerazad.hstu@gmail.com', '1234');
255
256 -- --------------------------------------------------------
257
258 --
259 -- Table structure for table `registration`
260 --
261
262 CREATE TABLE IF NOT EXISTS `registration` (
263 `donar_id` int(100) NOT NULL AUTO_INCREMENT,
264 `username` varchar(100) NOT NULL,
265 `gender` varchar(100) NOT NULL,
266 `age` varchar(100) NOT NULL,
267 `contact` varchar(100) NOT NULL,
268 `type` varchar(22) NOT NULL,
269 `city` varchar(221) NOT NULL,
270 `address` varchar(100) NOT NULL,
271 `bgroup` varchar(100) NOT NULL,
272 `dates` date NOT NULL,
273 `email` varchar(100) NOT NULL,
274 `password` int(100) NOT NULL,
275 `pic` varchar(1000) NOT NULL,
276 PRIMARY KEY (`donar_id`)
277 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=123 ;
278
279 --
280 -- Dumping data for table `registration`
281 --
282
283 INSERT INTO `registration` (`donar_id`, `username`, `gender`, `age`, `contact`, `type`, `city`, `address`, `bgroup`, `dates`, `email`, `password`, `pic`) VALUES
284 (86, 'Syeda Musharrat', 'female', '21', '01712292009', 'Blood Donor', 'Dinajpur', 'Ghashipara', 'O+', '0000-00-00', 'musharratnashrum.mn@gmail.com', 123, ''),
285 (87, 'Hussain Al Mortuza', 'male', '21', '01706742647', 'Blood Donor', 'Rangpur', 'Dhap', 'B+', '0000-00-00', 'mortuza1202089@gmail.com', 123, ''),
286 (88, 'Rumana Akter Ela', 'female', '21', '01734301217', 'Blood Donor', 'Dinajpur', 'Ramnagar', 'O+', '0000-00-00', 'elahstu@gmail.com', 123, ''),
287 (89, 'Miftahul Jannat', 'female', '22', '01734472278', 'Blood Seeker', 'Panchagarh', 'Panchagarh', 'O+', '0000-00-00', 'mj.nure@gmail.com', 123, ''),
288 (90, 'Farjana Lina', 'female', '21', '01773438430', 'Blood Seeker', 'Dinajpur', 'Basherhat', 'O+', '0000-00-00', 'lina73farjana@gmail.com', 123, ''),
289 (91, 'Dristy Das', 'female', '21', '01795660520', 'Blood Donor', 'Dinajpur', 'Kalitola', 'B+', '0000-00-00', 'dristydas.hstu@gmail.com', 123, ''),
290 (92, 'Hamidul Islam', 'male', '21', '01751318963', 'Blood Seeker', 'Kurigram', 'Razarhat', 'O+', '0000-00-00', 'imdhamidul13@gmail.com', 123, ''),
291 (93, 'Sirazum Monira', 'female', '22', '01757950876', 'Blood Donor', 'Dinajpur', 'Doshmail', 'O+', '0000-00-00', 'sirazum79@gmail.com', 123, ''),
292 (94, 'Atiya Sanjida Etu', 'female', '20', '01836022493', 'Blood Seeker', 'Dinajpur', 'Nimtola', 'B+', '0000-00-00', 'atiyasanjida42@gmail.com', 123, ''),
293 (95, 'Sazzad Hossain', 'male', '21', '017738783899', 'Blood Donor', 'Dinajpur', 'Birol', 'O+', '0000-00-00', 'sazzad1002@gmail.com', 123, ''),
294 (96, 'S.M. Janardan Roy', 'male', '21', '01738082848', 'Blood Donor', 'Thakurgaon', 'Setabgonj', 'A+', '0000-00-00', 'janardanroyhstu2013@gmail.com', 123, ''),
295 (97, 'Shafiqul Islam ', 'male', '21', '01722710298', 'Blood Donor', 'Panchagarh', 'Debigonj', 'O+', '0000-00-00', 'sujon.hstu.tee013@gmail.com', 123, ''),
296 (98, 'Uswatun Hasana ', 'female', '22', '01747125554', 'Blood Donor', 'Dinajpur', 'Paharpur', 'A+', '0000-00-00', 'uswatun.h5554@gmail.com', 123, ''),
297 (99, 'Keshob Ray', 'male', '21', '01761023408', 'Blood Donor', 'Rangpur', 'Keranir hat', 'B+', '0000-00-00', 'keshobrayhstu91@gmail.com', 123, ''),
298 (100, 'Md. Elias Hossain', 'male', '21', '01751119073', 'Blood Donor', 'Dinajpur', 'Kosba,Pulhat', 'B+', '0000-00-00', 'md.eliashossain13@gmail.com', 123, ''),
299 (101, 'Md. Azharul Islam', 'male', '21', '01764761919', 'Blood Donor', 'Nilphamari', 'saidpur', 'O+', '0000-00-00', 'azad.ece13@gmail.com', 123, ''),
300 (102, 'Maruf Hasan Piko', 'male', '21', '01737366366', 'Blood Donor', 'Rangpur', 'Dhap Kakolilane', 'O+', '0000-00-00', 'pikohasan73@gmail.com', 123, ''),
301 (103, 'Fatema Farin', 'female', '21', '01714442319', 'Blood Seeker', 'Jessore', 'West Barandipara', 'O+', '0000-00-00', 'fatema.farin13@gmail.com', 123, ''),
302 (104, 'Fahim Ahmed ', 'male', '21', '01765676686', 'Blood Seeker', 'Kushtia', 'Bheramara', 'O-', '0000-00-00', 'fahimahmed100@gmail.com', 123, ''),
303 (105, 'Mokarram Hossain', 'male', '22', '01723155254', 'Blood Donor', 'Nilphamari', 'Saidpur', 'A+', '0000-00-00', 'connect.with.me254@gmail.com', 123, ''),
304 (106, 'Arabi Mohammad ', 'male', '21', '01742827093', 'Blood Donor', 'Kurigram', 'Kurigram', 'B+', '0000-00-00', 'didar247@gmail.com', 123, ''),
305 (107, 'Ajmary Jahan Riny', 'female', '21', '01772974973', 'Blood Donor', 'Dinajpur', 'Uttor Faridpur', 'O+', '0000-00-00', 'ajmaryjahan@gmail.com', 123, ''),
306 (108, 'Resmi Rashid', 'female', '21', '01762946949', 'Blood Donor', 'Lalmonirhat', 'Mission more', 'B+', '0000-00-00', 'resmi.tee13@gmail.com', 123, ''),
307 (109, 'Sazia Haider', 'female', '21', '01705808656', 'Blood Donor', 'Dinajpur', 'Newtown 3', 'B+', '0000-00-00', 'saziahaidersizu@gmail.com', 123, ''),
308 (110, 'Shohel Rana', 'male', '21', '01761273269', 'Blood Donor', 'Thakurgaon', 'Pirgonj', 'A+', '0000-00-00', 'shohelhstu117@gmail.com', 123, ''),
309 (111, 'Al-Mamun', 'male', '22', '01746314882', 'Blood Donor', 'Nilphamari', 'Saidpur', 'AB+', '0000-00-00', 'mamunhstu13@gmail.com', 123, ''),
310 (112, 'Babul Hossain', 'male', '21', '01738421785', 'Blood Donor', 'Chapainawabganj', 'Shibgonj', 'B+', '0000-00-00', 'babul.hstu@gmail.com', 123, ''),
311 (113, 'Aysha Siddika Shova', 'female', '21', '01793965152', 'Blood Seeker', 'Dinajpur', 'Munshipara', 'B+', '0000-00-00', 'siddika.shova5152@gmail.com', 123, ''),
312 (114, 'Kanak Borman', 'male', '21', '01758964988', 'Blood Donor', 'Bogra', 'Adamdighi', 'A+', '0000-00-00', 'kanakborman@gmail.com', 123, ''),
313 (115, 'Mukesh Chaudhary', 'male', '21', '01794953611', 'Blood Donor', 'Dinajpur', 'HSTU', 'B+', '0000-00-00', 'mukesh101mak@gmail.com', 123, ''),
314 (116, 'username', 'female', '21', '3', 'Blood Seeker', 'Chapainawabganj', 'hstu', 'O-', '2017-11-29', 'azad.ece13@gmail.com', 123, ''),
315 (117, 'developerazad', 'male', '21', '01521470368', 'Blood Donor', 'Dinajpur', 'Dhaka', 'O-', '0000-00-00', 'developerazad.hstu@gmail.com', 111, ''),
316 (121, 'admin', '', '', '01764761919', '', 'Dinajpur', '', 'O+', '0000-00-00', 'admin@gmail.com', 123, ''),
317 (122, 'admin', '', '', '', '', '', '', '', '0000-00-00', '', 0, '');
318
319 -- --------------------------------------------------------
320
321 --
322 -- Table structure for table `requestes`
323 --
324
325 CREATE TABLE IF NOT EXISTS `requestes` (
326 `reg_id` int(100) NOT NULL AUTO_INCREMENT,
327 `name` varchar(100) NOT NULL,
328 `gender` varchar(100) NOT NULL,
329 `age` int(100) NOT NULL,
330 `mobile` varchar(100) NOT NULL,
331 `bgroup` varchar(100) NOT NULL,
332 `email` varchar(100) NOT NULL,
333 `reqdate` date NOT NULL,
334 `detail` varchar(100) NOT NULL,
335 PRIMARY KEY (`reg_id`)
336 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
337
338 --
339 -- Dumping data for table `requestes`
340 --
341
342 INSERT INTO `requestes` (`reg_id`, `name`, `gender`, `age`, `mobile`, `bgroup`, `email`, `reqdate`, `detail`) VALUES
343 (3, 'admin', 'male', 33, '01764761919', '', 'g@gmail.com', '2022-01-19', 'save life'),
344 (4, 'admin', 'male', 33, '01764761919', '', 'g@gmail.com', '2022-01-19', 'save life'),
345 (5, 'sanaaa', 'female', 21, '017777777', 'A-', 'g@gmail.com', '2017-12-01', 'save life'),
346 (6, 'sanaaa', 'female', 21, '017777777', 'A-', 'g@gmail.com', '2017-12-01', 'save life'),
347 (7, 'sanaaa', 'female', 21, '017777777', 'A-', 'g@gmail.com', '2017-12-01', 'save life'),
348 (8, 'sanaaa', 'female', 21, '017777777', 'A-', 'g@gmail.com', '2017-12-01', 'save life'),
349 (9, 'mamun', 'male', 22, '01777777', 'AB+', 'mamun@gmail.com', '0000-00-00', '');
350
351 -- --------------------------------------------------------
352
353 --
354 -- Table structure for table `user`
355 --
356
357 CREATE TABLE IF NOT EXISTS `user` (
358 `username` varchar(100) NOT NULL,
359 `password` varchar(100) NOT NULL,
360 `type` varchar(100) NOT NULL
361 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
362
363 --
364 -- Dumping data for table `user`
365 --
366
367 INSERT INTO `user` (`username`, `password`, `type`) VALUES
368 ('admin', 'admin', 'admin'),
369 ('adnim', '13020944', 'admin');
370
371 -- --------------------------------------------------------
372
373 --
374 -- Table structure for table `users`
375 --
376
377 CREATE TABLE IF NOT EXISTS `users` (
378 `username` varchar(100) NOT NULL,
379 `password` varchar(100) NOT NULL,
380 `type` varchar(100) NOT NULL
381 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
382
383 --
384 -- Dumping data for table `users`
385 --
386
387 INSERT INTO `users` (`username`, `password`, `type`) VALUES
388 ('adnim', '13020944', 'admin');
389
390 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
391 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
392 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;